//
//  HistoryDetailTableViewController.swift
//  ZTC_Final
//
//  Created by xy Man on 2022/5/28.
//

import UIKit

class HistoryDetailTableViewController: UITableViewController {

    var username:String=""
    var id:Int = -1
    var bookname:String = ""
    var price:String=""
    var time:String=""
    var number:Int = -1
    var queryres:[[String : AnyObject]]?=[]
    
    
    @IBOutlet weak var bottomId: UILabel!
    
    @IBOutlet weak var totalPrice: UILabel!
    
    override func viewDidLoad() {
        super.viewDidLoad()
        let xib = UINib(nibName: "HisDetailTableViewCell", bundle: nil)
        tableView.register(xib, forCellReuseIdentifier: "hisdetailcell")
        tableView.rowHeight = 157
        queryres = getQueryData(sql: "SELECT * FROM history WHERE username='\(username)' AND id=\(id) AND time='\(time)';")
        
        bottomId.text = "\(id)"
        totalPrice.text=String(format: "%.2f元", queryres![0]["totalprice"] as! Double)
        // Uncomment the following line to preserve selection between presentations
        // self.clearsSelectionOnViewWillAppear = false

        // Uncomment the following line to display an Edit button in the navigation bar for this view controller.
        // self.navigationItem.rightBarButtonItem = self.editButtonItem
    }
    
    func getQueryData(sql:String)->[[String : AnyObject]]?{
        let sqlite = SQLiteManager.sharedInstance
        if !sqlite.openDB(){return []}
        let queryres = sqlite.execQuerySQL(sql: sql)
        sqlite.closeDB()
        return queryres
    }
    
    func doNonSql(sql:String)->Void{
        let sqlite = SQLiteManager.sharedInstance
        if !sqlite.openDB(){return}
        if !sqlite.execNoneQuerySQL(sql: sql){return}
        sqlite.closeDB()
    }

    // MARK: - Table view data source

    override func numberOfSections(in tableView: UITableView) -> Int {
        // #warning Incomplete implementation, return the number of sections
        return 1
    }

    override func tableView(_ tableView: UITableView, numberOfRowsInSection section: Int) -> Int {
        // #warning Incomplete implementation, return the number of rows
        return queryres!.count
    }

    
    override func tableView(_ tableView: UITableView, cellForRowAt indexPath: IndexPath) -> UITableViewCell {
        let cell = tableView.dequeueReusableCell(withIdentifier: "hisdetailcell", for: indexPath) as! HisDetailTableViewCell

        // Configure the cell...
        cell.bookname.text = queryres![indexPath.row]["bookname"] as! String
        cell.number.text = "\(queryres![indexPath.row]["number"] as! Int)本"
        let singlePrice = getQueryData(sql: "SELECT price FROM book WHERE title='\(cell.bookname.text!)';")![0]["price"] as! Double
        cell.price.text = String(format: "%.2f元", singlePrice)
        cell.buytime.text = time
        return cell
    }
    

    /*
    // Override to support conditional editing of the table view.
    override func tableView(_ tableView: UITableView, canEditRowAt indexPath: IndexPath) -> Bool {
        // Return false if you do not want the specified item to be editable.
        return true
    }
    */

    /*
    // Override to support editing the table view.
    override func tableView(_ tableView: UITableView, commit editingStyle: UITableViewCell.EditingStyle, forRowAt indexPath: IndexPath) {
        if editingStyle == .delete {
            // Delete the row from the data source
            tableView.deleteRows(at: [indexPath], with: .fade)
        } else if editingStyle == .insert {
            // Create a new instance of the appropriate class, insert it into the array, and add a new row to the table view
        }    
    }
    */

    /*
    // Override to support rearranging the table view.
    override func tableView(_ tableView: UITableView, moveRowAt fromIndexPath: IndexPath, to: IndexPath) {

    }
    */

    /*
    // Override to support conditional rearranging of the table view.
    override func tableView(_ tableView: UITableView, canMoveRowAt indexPath: IndexPath) -> Bool {
        // Return false if you do not want the item to be re-orderable.
        return true
    }
    */

    /*
    // MARK: - Navigation

    // In a storyboard-based application, you will often want to do a little preparation before navigation
    override func prepare(for segue: UIStoryboardSegue, sender: Any?) {
        // Get the new view controller using segue.destination.
        // Pass the selected object to the new view controller.
    }
    */

}
